UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '15GH5lWBEUF2XqP676NvBjkHZt4c2T8vNb22JDG/AOk=' 
WHERE 
  key_id = 'e716ffc33368fbd6a139a90c5ea2c1eebbcd00978b5eec880cb20e1cf6bf4130' 
  AND (
    token = '15GH5lWBEUF2XqP676NvBjkHZt4c2T8vNb22JDG/AOk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037