UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'asDVyh01dP5Ds/evc6fTc2QbxR/A1k5l+3wIyps5wBI=' 
WHERE 
  key_id = '0e561398140f0d1e846509774e5ba2ce4f9a78bd140598a582d9691bfc0da86f' 
  AND (
    token = 'asDVyh01dP5Ds/evc6fTc2QbxR/A1k5l+3wIyps5wBI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022