UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0nBgSVLi2CK5YYCzlTH7TCLILLhdwvbkoAb3WnnBWN0='
WHERE
key_id = 'ca6d8455b4bbb0c61143dbbe9509cfb58fe6033ab276f9afdf9d9bdc0afc4677'
AND (
token = '0nBgSVLi2CK5YYCzlTH7TCLILLhdwvbkoAb3WnnBWN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)