UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMCJq81j3J1acKu7M0Y7CABUE3KW8gXoVXQoKO3jX1k='
WHERE
key_id = '7bf80c92fd6b2d430bd86095e643ce13137e37a3af792c0001d8e1a9f4f317c0'
AND (
token = 'BMCJq81j3J1acKu7M0Y7CABUE3KW8gXoVXQoKO3jX1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)