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