UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUBNtY5WuIlJZkTWZVp+spjfEf1e55XsHIraXY7UjiE='
WHERE
key_id = '22e71bca611023b2686850f6534164d5a6bd78ccd41af2d9c0df91ec6072e9c0'
AND (
token = 'TUBNtY5WuIlJZkTWZVp+spjfEf1e55XsHIraXY7UjiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)