UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VKig1p4CHPn25UwK4aLCexo8El8seKyJS0s09s9PBDI='
WHERE
key_id = 'cc1297f8f90527a3cd64800528696422a1c54d82cdb59cd0a7f569d70cfd5e22'
AND (
token = 'VKig1p4CHPn25UwK4aLCexo8El8seKyJS0s09s9PBDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)