UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4pCUpG0HbTXnJPILz21Dpo5YFAX5gX4p4VXYZwJNHCg='
WHERE
key_id = '25fe84e50350160a16f93a8d58a06710d84c5f64fec95c009a2cd1c155f606ee'
AND (
token = '4pCUpG0HbTXnJPILz21Dpo5YFAX5gX4p4VXYZwJNHCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)