UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b3XB96OJuFz5HhiX5kIKq9McWTl3kJOTD5JMl64W6CA='
WHERE
key_id = '9a018ddf62f086524e509d2ad760a0cb62b914e6a81c5b50d29ddd73815b84a1'
AND (
token = 'b3XB96OJuFz5HhiX5kIKq9McWTl3kJOTD5JMl64W6CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)