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