UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tKAE212hSnl6NK6ZmdsPte6rhvu5Vcm1A0JLes9b88w='
WHERE
key_id = '6c08ecf74e8cd5042407ab2cd8a2fb3271528dce90c442f5ddb9d67a082576c6'
AND (
token = 'tKAE212hSnl6NK6ZmdsPte6rhvu5Vcm1A0JLes9b88w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)