UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPbBq74SrIFUhxmwA+E9Gk8K05Jfa3hHrpenBO4N3Qc='
WHERE
key_id = 'ee57e41e4b0c395a7b82d224de927fc20a9f027abe9a650284758617c123b1e4'
AND (
token = 'BPbBq74SrIFUhxmwA+E9Gk8K05Jfa3hHrpenBO4N3Qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)