UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qVZpWPjIt5KRoS18dlTvJ1njaLSCya/CGlNAgCdEIaU='
WHERE
key_id = 'cfae9cda0ac5b6625fc5c5b1a1b5d7e58c3c3b5c30d6893304963d44d5862ac6'
AND (
token = 'qVZpWPjIt5KRoS18dlTvJ1njaLSCya/CGlNAgCdEIaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)