UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZUk789cTP5D/DbZNbcpWqBeuWInKmZzbSLtmHTGfthE=' 
WHERE 
  key_id = 'fd726b27a23204a62a8c887471b3fbfd6db50ee6d31ee570a6a64387eceab871' 
  AND (
    token = 'ZUk789cTP5D/DbZNbcpWqBeuWInKmZzbSLtmHTGfthE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025