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