UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4CDixr2tZF1NIj/yKa7tChCRsuIewej4ikPv0hraZU='
WHERE
key_id = '0fcff8de3ca4b94cf15999202625105b62cea0a830ea427807c47c8fb88b326f'
AND (
token = 'd4CDixr2tZF1NIj/yKa7tChCRsuIewej4ikPv0hraZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)