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