UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sOTTIzJv5PExy76hKNdXIK6f2XBFCXIJRlXahSTFuj4='
WHERE
key_id = 'f1d69780091add6b184bf24eddc0656c3d9340f0019317354e707a6abdb6062c'
AND (
token = 'sOTTIzJv5PExy76hKNdXIK6f2XBFCXIJRlXahSTFuj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)