UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIJH+jFpqF5RtI5fU50e0T8mU0yH6KiS3jse4F34L2A='
WHERE
key_id = 'de800028b6007248dc1e7ad4b181819fef7d938093df816847c8a05034077bad'
AND (
token = 'qIJH+jFpqF5RtI5fU50e0T8mU0yH6KiS3jse4F34L2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)