UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'x+s92+BUFM4inv/BKrqdcOAzXPAX/rmUuym/cOY/LLs=' 
WHERE 
  key_id = 'f917e95bd5d39dc690d7d1396d12f10ec83f5b1a9beecbcd08e3af7dcae3d792' 
  AND (
    token = 'x+s92+BUFM4inv/BKrqdcOAzXPAX/rmUuym/cOY/LLs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034