UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7eLFpY6+IVujd1ypb4XPNUZdUVBRJvNoIhwAkkFiZkE='
WHERE
key_id = '48c99fa892e69af5ea1850c163e3bafd8955b3082a35af765bd4f8545ab7e94a'
AND (
token = '7eLFpY6+IVujd1ypb4XPNUZdUVBRJvNoIhwAkkFiZkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)