UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QGh3xY/P9gQ0VLsWGhI7prHcLMV8gMFTIL1nAxh8Kos='
WHERE
key_id = 'b784715b3a06d21cfc920d3d8bf3056901bab65a6b1ad4c9fd8e5facd5e1533f'
AND (
token = 'QGh3xY/P9gQ0VLsWGhI7prHcLMV8gMFTIL1nAxh8Kos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)