UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xbJGPuOTa+91ebCF7zzhsEBAJWF2QIOtnc6JdM3yNnM='
WHERE
key_id = '9924c53f611d5e1a042d51f90c456d26b548e507dfe68b7d0c5625336dae77dd'
AND (
token = 'xbJGPuOTa+91ebCF7zzhsEBAJWF2QIOtnc6JdM3yNnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)