UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zWWlY0BQ4fTnj6krfNrkWjyJBkzRRYiC/19r0DaORsI=' 
WHERE 
  key_id = 'a59cae0c207e760cbe3275ff5c64303f29daccebbdfb03f2f69aae6e948a0cbe' 
  AND (
    token = 'zWWlY0BQ4fTnj6krfNrkWjyJBkzRRYiC/19r0DaORsI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023