UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mEzOYN5oKsHbEUCTmcJgwxCicyIPsLx6wBstrckBra8='
WHERE
key_id = '0e840e3ac89ef396e79b9fb2b0a95a10849752ba5b5a57bcf5e39aacff7769e9'
AND (
token = 'mEzOYN5oKsHbEUCTmcJgwxCicyIPsLx6wBstrckBra8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)