UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qwfpTIJF3T36UPtkA4nPRN8aEjwQbLj4oadGMMvUyNE='
WHERE
key_id = '9e5ac1e36def1d5bbf8be66d4d8d9adc2a4fd1d1afab580e64981348602f898a'
AND (
token = 'qwfpTIJF3T36UPtkA4nPRN8aEjwQbLj4oadGMMvUyNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)