UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'f8T1WKbrZ0v+R3Xd1O8Jmw1Ah/SRdSt+h2Z1Nzo9AEQ=' 
WHERE 
  key_id = '2e3a9056731e59a7494ac5d8b8bc0b27b81c084b40652f79918c2ea238929222' 
  AND (
    token = 'f8T1WKbrZ0v+R3Xd1O8Jmw1Ah/SRdSt+h2Z1Nzo9AEQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027