UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qmh0ed5HvEao3eOUFSkutJf5JcGhsvXeG4XZEggTGkc='
WHERE
key_id = 'fd93324f58fc95bacc89f83b980122983eda86ad33462f076f4937a5e3c80397'
AND (
token = 'qmh0ed5HvEao3eOUFSkutJf5JcGhsvXeG4XZEggTGkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)