UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mfyiQCOksO3NcesSJIpAjichacJN9988Di8ifm1EKSE='
WHERE
key_id = '7b4b169ed8eefb9dcb49a2a95f61a056081b0e25353e6f04adeebf5105ed5694'
AND (
token = 'mfyiQCOksO3NcesSJIpAjichacJN9988Di8ifm1EKSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)