UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Gk+e2MZvY4gguZxLo2/FLfM5W5RJKpLtSubEv5y3ss='
WHERE
key_id = '6ce8cb11636388d775141430de34411f4f9ff745b6a55d890a3a37402e732fb3'
AND (
token = '/Gk+e2MZvY4gguZxLo2/FLfM5W5RJKpLtSubEv5y3ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)