UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WIB8lZlzaodyttY5grfIp/zW4Tvu9i/i0JsD9slHZX4='
WHERE
key_id = 'c43a6e35c016ecde12365515249b72f9297e626e39e736a80153d0f21fc5e7f2'
AND (
token = 'WIB8lZlzaodyttY5grfIp/zW4Tvu9i/i0JsD9slHZX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)