UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cZTNCrRueyrsDUHF7bsKL4zN1X3tz09G/J4aW8uaLaQ=' 
WHERE 
  key_id = '40d31b62ed57f56d622b24878eaab6614865ee56598387dc3e79b079fad41386' 
  AND (
    token = 'cZTNCrRueyrsDUHF7bsKL4zN1X3tz09G/J4aW8uaLaQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00050