UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5fuY3HR/T5xZrEidXCF9xUw/yGCvQ8jfkgY8ZAmvaeU=' 
WHERE 
  key_id = '8cac7466e4facc0f19e7ae1d9c13fa1e3b65b8cbf52fb3e4b09846605ea1709a' 
  AND (
    token = '5fuY3HR/T5xZrEidXCF9xUw/yGCvQ8jfkgY8ZAmvaeU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031