UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZCj+idjF9AfZz61DCQRbVysKRp1oDSr//sFNZFks7I='
WHERE
key_id = '5419b6cdd82270e78bf1a844b94fd5a75fb91d7377856788e87458909b13cbfe'
AND (
token = 'qZCj+idjF9AfZz61DCQRbVysKRp1oDSr//sFNZFks7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)