UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n4Z9xYeN7fl63u+NAb1S2j2u126fxDwCx3eQjdM/NuY='
WHERE
key_id = '078aeb379de83bf24610fef563f0ab1db88311cfcdf56ecb0dfeb7ca37ba1638'
AND (
token = 'n4Z9xYeN7fl63u+NAb1S2j2u126fxDwCx3eQjdM/NuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)