UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3J9GNLisM0mAOdOobY90TnGs4M3cH0RyDHjmttaDxYc='
WHERE
key_id = 'e9f1d8e5460685b610e7ce279e7302a1de126fa410b71a1f92689e22d13136b7'
AND (
token = '3J9GNLisM0mAOdOobY90TnGs4M3cH0RyDHjmttaDxYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)