UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iBj4m/69XXrKKlDYm913Qwb09G3JWmHnjVDiyU4aOCk='
WHERE
key_id = 'b00789b4a9a750c43f0c5682ce64ba99089baf24d6b39ddf17e154a2c2cdc2ee'
AND (
token = 'iBj4m/69XXrKKlDYm913Qwb09G3JWmHnjVDiyU4aOCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)