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