UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jN7fsYfB3BB+zSpkdvPISWyMpihawLUAT/osfojo8hk='
WHERE
key_id = '4db0e91aa77ed42b846eb6f549ae6c1e9b1fcdddcf213fbbfc8fc70fc2078031'
AND (
token = 'jN7fsYfB3BB+zSpkdvPISWyMpihawLUAT/osfojo8hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)