UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcK2BVqTeH9beNHObMIvXrBDohS5dLu5yVnRDKnGAx8='
WHERE
key_id = '629291917d10c90d579c8c8201d6d81edb3785d5ec2e1c5dbbf24f30d06b3cb1'
AND (
token = 'BcK2BVqTeH9beNHObMIvXrBDohS5dLu5yVnRDKnGAx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)