UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gWzp09Xn7VfVQGmCCm5GevYIRr1xtDM5GHs+cjWlDPE=' 
WHERE 
  key_id = '4b83371d17d6cd74c80dd4a6cd14d3e567b8c191f2079299b1a68e8595454697' 
  AND (
    token = 'gWzp09Xn7VfVQGmCCm5GevYIRr1xtDM5GHs+cjWlDPE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038