UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcWfxyA006qI3RbLh3DBmtuYUmhnGqCCzreUk1jrJkU='
WHERE
key_id = '142d9beb8f5e5c2b1dd25ec013d0a4774d2b7afa8840b1564f3188ad01116a89'
AND (
token = 'bcWfxyA006qI3RbLh3DBmtuYUmhnGqCCzreUk1jrJkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)